package bdd;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;

/**
 *
 * @author flo
 */
public class InitialisationTables {

    public Connection c = null;
    public Statement stmt = null;

    public void init() throws SQLException {
        c = ConnecterBase.Connect();
        stmt = c.createStatement();
        
        
        
        /************ TABLE PHRASES *****************/
        String sql = "DELETE FROM PHRASES";
        stmt.executeUpdate(sql);
        
        sql = "DELETE FROM SQLITE_SEQUENCE WHERE name='PHRASES';";
        stmt.executeUpdate(sql);
        
        sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('A dash of is a big portion of something',0);";
        stmt.executeUpdate(sql);
        
        sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('Lashings of means a lot of',1);";
        stmt.executeUpdate(sql);
        
        sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('Out of the blue means suddenly',1);";
        stmt.executeUpdate(sql);
        
        sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('A kick in the teeth means to feel insulted',1);";
        stmt.executeUpdate(sql);
        
        sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('Play by ear means to play it safe',0);";
        stmt.executeUpdate(sql);
        
        sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('Horrid and horrible is the same',1);";
        stmt.executeUpdate(sql);
        
        sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('When I am alone, I listen music. This is a correct sentence',0);";
        stmt.executeUpdate(sql);
        
        sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('He speaks a good English. This is a correct sentence',0);";
        stmt.executeUpdate(sql);
        
        sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('Describe me this man. This is a correct sentence',0);";
        stmt.executeUpdate(sql);
        
        sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('I am used to smiling. This is a correct sentence',1);";
        stmt.executeUpdate(sql);
        
        sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('I explained her the problem. This is a correct sentence',0);";
        stmt.executeUpdate(sql);
        
        sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('She took me all the papers. This is a correct sentence',0);";
        stmt.executeUpdate(sql);
        
        
        
            sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('To cut in past tense is cutted',0);";
        stmt.executeUpdate(sql);
        
            sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('The word -developement- is correctly written',0);";
        stmt.executeUpdate(sql);
        
            sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('To abide in past tense is abided',0);";
        stmt.executeUpdate(sql);
        
              sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('To bear in past tense is bore',1);";
        stmt.executeUpdate(sql);
        
         sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('To quit in past tense is quit',1);";
        stmt.executeUpdate(sql);
        
         sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('To rend in past tense is rend',0);";
        stmt.executeUpdate(sql);
        
         sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('To seek in past tense is sought',1);";
        stmt.executeUpdate(sql);
        
        
        sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('To shed in past tense is sheded',0);";
        stmt.executeUpdate(sql);
        
        sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('To shoe in past tense is shod',1);";
        stmt.executeUpdate(sql);
        
        sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('To shut in past tense is shut',1);";
        stmt.executeUpdate(sql);
        
        sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('To slay in past tense is slew',1);";
        stmt.executeUpdate(sql);
        
        sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('To slit in past tense is slit',1);";
        stmt.executeUpdate(sql);
        
        sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('To spin in past tense is spinned',0);";
        stmt.executeUpdate(sql);
        
        sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('To stink in past tense is stank',1);";
        stmt.executeUpdate(sql);
        
              sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('To bleeded in past tense is bleeded',0);";
        stmt.executeUpdate(sql);
        
              sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('To broadcast in past tense is broadcast',1);";
        stmt.executeUpdate(sql);
        
              sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('To burst in past tense is bursted',0);";
        stmt.executeUpdate(sql);
        
              sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('To cast in past tense is casted',0);";
        stmt.executeUpdate(sql);
        
              sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('To creep in past tense is crept',1);";
        stmt.executeUpdate(sql);
        
              sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('To dive in past tense is dived',1);";
        stmt.executeUpdate(sql);
        
              sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('To forbid in past tense is forbided',0);";
        stmt.executeUpdate(sql);
        
              sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('To hurt in past tense is hurt',1);";
        stmt.executeUpdate(sql);
        
              sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('To relay in past tense is relayed',0);";
        stmt.executeUpdate(sql);
        


        sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('I am used to study means you do it regulary',0);";
        stmt.executeUpdate(sql);
        
        sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('To ensure and to make sure is the same',1);";
        stmt.executeUpdate(sql);
        
        sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('Jeopardy is when it is safe',0);";
        stmt.executeUpdate(sql);
        
        sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('Could have means that it was not possible and it did not happen',0);";
        stmt.executeUpdate(sql);
        
        sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('Fuzzy means obsessed',0);";
        stmt.executeUpdate(sql);
        
        sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('To sort out is to solve things',1);";
        stmt.executeUpdate(sql);
        
        sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('thingumajig is a real word',1);";
        stmt.executeUpdate(sql);
        
        sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('umpteen means small amount of',0);";
        stmt.executeUpdate(sql);
        
        
        sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('Lackluster means boring',1);";
        stmt.executeUpdate(sql);
        
        sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('Dull and uninteresting are different',0);";
        stmt.executeUpdate(sql);
        
        
        sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('To imply and to entail are different',0);";
        stmt.executeUpdate(sql);
        
        sql = "INSERT INTO PHRASES (PHRASE,VALEUR) "
                + "VALUES ('A smattering is a big portion of something',0);";
        stmt.executeUpdate(sql);
        
        
        /*******  TABLE MOT ********************/
      /*  sql = "DELETE FROM MOTS";
        stmt.executeUpdate(sql);
        
        sql = "DELETE FROM SQLITE_SEQUENCE WHERE name='MOTS';";
        stmt.executeUpdate(sql);
        
        sql = "INSERT INTO MOTS (MOT,VALEUR) "
                + "VALUES ('kernel',1);";
        stmt.executeUpdate(sql);
        
        sql = "INSERT INTO MOTS (MOT,VALEUR) "
                + "VALUES ('adress',0);";
        stmt.executeUpdate(sql);
        
        sql = "INSERT INTO MOTS (MOT,VALEUR) "
                + "VALUES ('length',1);";*/
        
        
        stmt.executeUpdate(sql);
        stmt.close();
        c.close();
    }
}
